<?php
return array(
  // configure the underlying pdo connection
  'connection' => array(
    'dsn'      => 'mysql:host=localhost;dbname=bandinabottle',
    'username' => 'root',
    'password' => '',
    'dialect' => 'mysql'
  ),
 
  // map each class and their properties to their corresponding tables and columns
  // also map the associations between classes
  'classes' => array(
    'Content' => array(
      'table' => 'biab_contents',
      'props' => array(
        'ID'			=> array('ID', 'int', array('pk'=>true, 'autoIncrement'=>true)),
        'title'			=> array('title', 'varchar'),
  		'shortDesc'		=> array('shortDesc', 'varchar'),
		'content'		=> array('content', 'text'),
		'tags'			=> array('tags', 'varchar'),
		'user'			=> array('user', 'int'),
		'type'			=> array('type', 'int'),
		'currentDate'	=> array('currentDate', 'datetime'),  
      )
    ),
    'Event' => array(
      'table' => 'biab_events',
      'props' => array(
        'ID'			=> array('ID', 'int', array('pk'=>true, 'autoIncrement'=>true)),
        'title'			=> array('title', 'varchar'),
  		'shortDesc'		=> array('shortDesc', 'varchar'),
		'content'		=> array('content', 'text'),
		'tags'			=> array('tags', 'varchar'),
   		'address'		=> array('address', 'varchar'),
   		'src'			=> array('src', 'varchar'),
   		'date'			=> array('date', 'datetime'),
		'user'			=> array('user', 'int'),
		'type'			=> array('type', 'int'),
   		'stat'			=> array('stat', 'int'),
		'currentDate'	=> array('currentDate', 'datetime'),  
      )
    ),
    'Media' => array(
      'table' => 'biab_medias',
      'props' => array(
        'ID'			=> array('ID', 'int', array('pk'=>true, 'autoIncrement'=>true)),
        'title'			=> array('title', 'varchar'),
  		'shortDesc'		=> array('shortDesc', 'varchar'),
		'content'		=> array('content', 'varchar'),
	    'src'			=> array('src', 'varchar'),
		'tags'			=> array('tags', 'varchar'),   		
   		'date'			=> array('date', 'datetime'),
		'user'			=> array('user', 'int'),
		'type'			=> array('type', 'int'),
		'currentDate'	=> array('currentDate', 'datetime'),  
      )
    ),
    'User' => array(
      'table' => 'biab_users',
      'props' => array(
        'ID'			=> array('ID', 'int', array('pk'=>true, 'autoIncrement'=>true)),
        'username'		=> array('username', 'varchar'),
  		'password'		=> array('password', 'varchar'),
		'email'			=> array('email', 'varchar'),
		'type'			=> array('type', 'boolean'),
		'currentDate'	=> array('currentDate', 'datetime'),  
      )
    )
  )
);